/*
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *  http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */

suite("aggregate_no_group_null") {
    sql "DROP TABLE IF EXISTS t1_int;"
    sql """
	CREATE TABLE `t1_int` (
       `num` int(11) NULL,
       `dgs_jkrq` bigint(20) NULL
    ) ENGINE=OLAP
    DUPLICATE KEY(`num`)
    COMMENT 'OLAP'
    DISTRIBUTED BY HASH(`num`) BUCKETS 1
    PROPERTIES (
    "replication_allocation" = "tag.location.default: 1",
    "storage_format" = "V2",
    "light_schema_change" = "true",
    "disable_auto_compaction" = "false",
    "enable_single_replica_compaction" = "false"
    );
    """
    sql """insert into t1_int values(1,1),(1,2),(1,3),(1,4),(1,null);"""
    qt_sql """
       select min(dgs_jkrq) from t1_int;
    """

    sql "DROP TABLE t1_int"
}
